USE [TinyForum]
GO
/****** Object:  Table [dbo].[Replies]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Replies]
GO
/****** Object:  Table [dbo].[Posts]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Posts]
GO
/****** Object:  Table [dbo].[Contents]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Contents]
GO
/****** Object:  Table [dbo].[Settings]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Settings]
GO
/****** Object:  Table [dbo].[Topics]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Topics]
GO
/****** Object:  Table [dbo].[Accounts]    Script Date: 02/17/2012 15:09:54 ******/
DELETE FROM [dbo].[Accounts]
GO
/****** Object:  Table [dbo].[Accounts]    Script Date: 02/17/2012 15:09:54 ******/
SET IDENTITY_INSERT [dbo].[Accounts] ON
INSERT [dbo].[Accounts] ([ID], [UserName], [Password], [DisplayName], [Avatar], [Email], [DateJoined], [DateLastLogon], [IsAdmin], [PasswordQuestion], [PasswordAnswer]) VALUES (13, N'daxnet', N'123456', N'dax.net', N'', N'daxnet@live.com', CAST(0x00009FBA0147BB38 AS DateTime), NULL, 1, N'Your school name?', N'XiangFang mid-school')
INSERT [dbo].[Accounts] ([ID], [UserName], [Password], [DisplayName], [Avatar], [Email], [DateJoined], [DateLastLogon], [IsAdmin], [PasswordQuestion], [PasswordAnswer]) VALUES (14, N'acqy', N'123456', N'Sunny Chen', NULL, N'acqy@163.com', CAST(0x00009FBA01613130 AS DateTime), NULL, 1, N'Your school name?', N'XiangFang mid-school')
SET IDENTITY_INSERT [dbo].[Accounts] OFF
/****** Object:  Table [dbo].[Topics]    Script Date: 02/17/2012 15:09:54 ******/
SET IDENTITY_INSERT [dbo].[Topics] ON
INSERT [dbo].[Topics] ([ID], [Name], [Description]) VALUES (1, N'.NET Architecture Technologies', N'Contains posts which are related to .NET architecture technologies.')
INSERT [dbo].[Topics] ([ID], [Name], [Description]) VALUES (4, N'Java Technologies', N'Contains posts which are related to Java.')
INSERT [dbo].[Topics] ([ID], [Name], [Description]) VALUES (5, N'Compiler Technologies', N'Discuss the compiler technology.')
SET IDENTITY_INSERT [dbo].[Topics] OFF
/****** Object:  Table [dbo].[Settings]    Script Date: 02/17/2012 15:09:54 ******/
SET IDENTITY_INSERT [dbo].[Settings] ON
INSERT [dbo].[Settings] ([ID], [SiteTitle], [SiteDescription], [SiteCopyright], [SiteTheme], [PostsPerPage], [RepliesPerPage]) VALUES (1, N'Tiny Forum', N'A Simple Forum', N'Copyright (C) hp.com', N'Default', 50, 50)
SET IDENTITY_INSERT [dbo].[Settings] OFF
/****** Object:  Table [dbo].[Contents]    Script Date: 02/17/2012 15:09:54 ******/
SET IDENTITY_INSERT [dbo].[Contents] ON
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (1, N'About the Enterprise Library', N'Does anybody know how to use the Enterprise Library?', CAST(0x00009FBE010FE960 AS DateTime), NULL, 14)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (2, N'RE: About the Enterprise Library', N'Yes, I know that.', CAST(0x00009FBE014159A0 AS DateTime), NULL, 13)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (4, N'RE: About the Enterprise Library', N'Thank you very much!', CAST(0x00009FBE0142B930 AS DateTime), NULL, 14)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (5, N'DevArt dotConnection for Oracle', N'I was failed when using DevArt, any idea?', CAST(0x00009FBE01499700 AS DateTime), NULL, 13)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (6, N'RE: DevArt dotConnection for Oracle', N'Resolved.', CAST(0x00009FBE01549380 AS DateTime), NULL, 13)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (7, N'How to implement the Attributes in Java?', N'How to implement the Attributes in Java?', CAST(0x00009FBF007CB1E0 AS DateTime), NULL, 14)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (8, N'RE: How to implement the Attributes in Java?', N'I have no idea, maybe you need to query the Java community.', CAST(0x00009FBF008116E0 AS DateTime), NULL, 13)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (9, N'RE: How to implement the Attributes in Java?', N'I think you can use annotations in comments to simulate the Attributes.', CAST(0x00009FBF00827670 AS DateTime), NULL, 13)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (10, N'RE: How to implement the Attributes in Java?', N'Thank you very much! That''s it! >_<', CAST(0x00009FBF008462A0 AS DateTime), NULL, 14)
INSERT [dbo].[Contents] ([ID], [Title], [Content], [DateCreated], [DateModified], [UserID]) VALUES (11, N'RE: About the Enterprise Library', N'You''re welcome.', CAST(0x00009FBF00DF05C0 AS DateTime), NULL, 13)
SET IDENTITY_INSERT [dbo].[Contents] OFF
/****** Object:  Table [dbo].[Posts]    Script Date: 02/17/2012 15:09:54 ******/
INSERT [dbo].[Posts] ([ContentID], [TopicID]) VALUES (1, 1)
INSERT [dbo].[Posts] ([ContentID], [TopicID]) VALUES (5, 1)
INSERT [dbo].[Posts] ([ContentID], [TopicID]) VALUES (7, 4)
/****** Object:  Table [dbo].[Replies]    Script Date: 02/17/2012 15:09:54 ******/
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (2, 1)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (4, 1)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (6, 5)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (8, 7)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (9, 7)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (10, 7)
INSERT [dbo].[Replies] ([ContentID], [PostID]) VALUES (11, 1)
